/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package wf.dto.georef;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedNativeQueries;
import javax.persistence.NamedNativeQuery;

/**
 *
 * @author edsonsuarez
 */
@Entity
@NamedNativeQueries({
    @NamedNativeQuery(
	name = "georef.pfpunpelg",
    query = "select zp.co_zonpeg, pg.nu_geolat, pg.nu_geolon, zp.va_radios, zp.no_zonpeg from zonpeg.tbzonpeg zp inner join georef.tbpungeo pg on zp.co_zonpeg = pg.id_pungeo",
    resultClass = pfpunpelg.class)
})
public class pfpunpelg {

    @Id
    @Column(name = "co_zonpeg")
    private int co_zonpeg;
    @Column(name = "nu_geolat")
    private double nu_geolat;
    @Column(name = "nu_geolon")
    private double nu_geolon;
    @Column(name = "va_radios")
    private int va_radios;
    @Column(name = "no_zonpeg")
    private String no_zonpeg;

    public int getCo_zonpeg() {
        return co_zonpeg;
    }

    public void setCo_zonpeg(int co_zonpeg) {
        this.co_zonpeg = co_zonpeg;
    }

    public double getNu_geolat() {
        return nu_geolat;
    }

    public void setNu_geolat(double nu_geolat) {
        this.nu_geolat = nu_geolat;
    }

    public double getNu_geolon() {
        return nu_geolon;
    }

    public void setNu_geolon(double nu_geolon) {
        this.nu_geolon = nu_geolon;
    }

    public int getVa_radios() {
        return va_radios;
    }

    public void setVa_radios(int va_radios) {
        this.va_radios = va_radios;
    }

    public String getNo_zonpeg() {
        return no_zonpeg;
    }

    public void setNo_zonpeg(String no_zonpeg) {
        this.no_zonpeg = no_zonpeg;
    }
}
